# -*- coding:utf-8 -*-
"""
Author：Administrator
Date:2023年03月18日
"""
import openpyxl

myBook = openpyxl.load_workbook('层剪力.xlsx')
mySheet = myBook.active
mySheet.delete_cols(6, 2)
mySheet.delete_cols(2, 1)
mySheet.delete_rows(1, 2)
for myRow in range(mySheet.max_row, 0, -1):
	if mySheet.cell(myRow, 1).value == '屋顶' or "(全部)" not in mySheet.cell(myRow, 2).value:
		mySheet.delete_rows(myRow)
myBook.save('结果表-层剪力表.xlsx')
